2013-06-12 - 7490 - Rel Notes - License Tracker #BIReleases2013

Release Notes:

7490 - License Tracker


Admin Info

Purpose
 Need to include Group order, parameter and Changing the report structure for SA300 Crystal Report
Release No
 001
Submitted
 06/12/2013
Submitted by
 Praveen Guntuka
Source/Destination Systems
 IT > BMS > Quality to IT > BMS > Production in SAP BOBI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Praveen Guntuka
Object(s) Tested By
 Praveen Guntuka

Report Name

SA300 - Sales Analysis by Region, License and Sales Org

BEx Query

ZMP_OPASA_Q036

NEC Crystal Reports Standards Check

1. SA300 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA300 NEC CR checklist has been sent to NEC and also attached here for reference:
SA300 NEC CR Standard Check List.xlsx

Summary Level Check

Test Conducted

Group : All
SNo
 Test Case
 Test Case
 Test Case
 Value in BEx Query
 Value in Crystal Report
 Pass/Fail
1
 2013
 Actual Revenue
 Jan
 31,542,308.09
 31,542,308
 Pass
2
 2013
 Actual Revenue
 Feb
 56,181,951.38
 56,181,951
 Pass
3
 2013
 Actual Revenue
 Mar
 58,831,124.77
 58,831,125
 Pass
4
 2013
 Actual Revenue
 Apr
 42,726,839.02
 42,726,839
 Pass
5
 2013
 Actual Revenue
 May
 43,961,386.15
 43,961,386
 Pass
6
 2013
 Actual Revenue
 Jun
 11,181,624.78
 11,181,625
 Pass
7
 2013
 Actual Revenue
 Jul
 No Value
 0
 Pass
8
 2013
 Actual Revenue
 Aug
 No Value
 0
 Pass
9
 2013
 Actual Revenue
 Sep
 No Value
 0
 Pass
10
 2013
 Actual Revenue
 Oct
 No Value
 0
 Pass
11
 2013
 Actual Revenue
 Nov
 No Value
 0
 Pass
12
 2013
 Actual Revenue
 Dec
 No Value
 0
 Pass
13
 2013
 Actual Revenue
 Total
 244,425,234.19
 244,425,234
 Pass
14
 2013
 Open Value
 Jan
 28,528.36
 28,528
 Pass
15
 2013
 Open Value
 Feb
 1,371.27
 1,371
 Pass
16
 2013
 Open Value
 Mar
 20,785.14
 20,785
 Pass
17
 2013
 Open Value
 Apr
 56,594.08
 56,594
 Pass
18
 2013
 Open Value
 May
 614,241.76
 614,242
 Pass
19
 2013
 Open Value
 Jun
 35,218,778.90
 35,218,779
 Pass
20
 2013
 Open Value
 Jul
 43,635,177.67
 43,635,178
 Pass
21
 2013
 Open Value
 Aug
 38,725,656.93
 38,725,657
 Pass
22
 2013
 Open Value
 Sep
 31,621,372.74
 31,621,373
 Pass
23
 2013
 Open Value
 Oct
 20,818,341.84
 20,818,342
 Pass
24
 2013
 Open Value
 Nov
 6,862,156.76
 6,862,157
 Pass
25
 2013
 Open Value
 Dec
 1,290,978.99
 1,290,979
 Pass
26
 2013
 Open Value
 Total
 178,893,984.44
 178,893,984
 Pass
27
 2013
 Total Revenue
 Jan
 31,570,836.45
 31,570,836
 Pass
28
 2013
 Total Revenue
 Feb
 56,183,322.65
 56,183,323
 Pass
29
 2013
 Total Revenue
 Mar
 58,851,909.91
 58,851,910
 Pass
30
 2013
 Total Revenue
 Apr
 42,783,433.10
 42,783,433
 Pass
31
 2013
 Total Revenue
 May
 44,575,627.91
 44,575,628
 Pass
32
 2013
 Total Revenue
 Jun
 46,400,403.68
 46,400,404
 Pass
33
 2013
 Total Revenue
 Jul
 43,635,177.67
 43,635,178
 Pass
34
 2013
 Total Revenue
 Aug
 38,725,656.93
 38,725,657
 Pass
35
 2013
 Total Revenue
 Sep
 31,621,372.74
 31,621,373
 Pass
36
 2013
 Total Revenue
 Oct
 20,818,341.84
 20,818,342
 Pass
37
 2013
 Total Revenue
 Nov
 6,862,156.76
 6,862,157
 Pass
38
 2013
 Total Revenue
 Dec
 1,290,978.99
 1,290,979
 Pass
39
 2013
 Total Revenue
 Total
 423,319,218.63
 423,319,219
 Pass
40
 2012
 Actual Revenue
 Jan
 17,923,108.58
 17,923,109
 Pass
41
 2012
 Actual Revenue
 Feb
 40,630,108.50
 40,630,109
 Pass
42
 2012
 Actual Revenue
 Mar
 61,590,961.71
 61,590,962
 Pass
43
 2012
 Actual Revenue
 Apr
 36,624,542.56
 36,624,543
 Pass
44
 2012
 Actual Revenue
 May
 45,348,931.68
 45,348,932
 Pass
45
 2012
 Actual Revenue
 Jun
 57,921,480.56
 57,921,481
 Pass
46
 2012
 Actual Revenue
 Jul
 51,672,007.55
 51,672,008
 Pass
47
 2012
 Actual Revenue
 Aug
 56,808,673.07
 56,808,673
 Pass
48
 2012
 Actual Revenue
 Sep
 63,316,595.27
 63,316,595
 Pass
49
 2012
 Actual Revenue
 Oct
 51,135,723.81
 51,135,724
 Pass
50
 2012
 Actual Revenue
 Nov
 52,803,467.04
 52,803,467
 Pass
51
 2012
 Actual Revenue
 Dec
 26,844,941.92
 26,844,942
 Pass
52
 2012
 Actual Revenue
 Total
 562,620,542.25
 562,620,542
 Pass
53
 2012
 Open Value
 Jan
 No Value
 0
 Pass
54
 2012
 Open Value
 Feb
 No Value
 0
 Pass
55
 2012
 Open Value
 Mar
 No Value
 0
 Pass
56
 2012
 Open Value
 Apr
 No Value
 0
 Pass
57
 2012
 Open Value
 May
 No Value
 0
 Pass
58
 2012
 Open Value
 Jun
 No Value
 0
 Pass
59
 2012
 Open Value
 Jul
 No Value
 0
 Pass
60
 2012
 Open Value
 Aug
 No Value
 0
 Pass
61
 2012
 Open Value
 Sep
 No Value
 0
 Pass
62
 2012
 Open Value
 Oct
 No Value
 0
 Pass
63
 2012
 Open Value
 Nov
 No Value
 0
 Pass
64
 2012
 Open Value
 Dec
 No Value
 0
 Pass
65
 2012
 Open Value
 Total
 No Value
 0
 Pass
66
 2012
 Total Revenue
 Jan
 17,923,108.58
 17,923,109
 Pass
67
 2012
 Total Revenue
 Feb
 40,630,108.50
 40,630,109
 Pass
68
 2012
 Total Revenue
 Mar
 61,590,961.71
 61,590,962
 Pass
69
 2012
 Total Revenue
 Apr
 36,624,542.56
 36,624,543
 Pass
70
 2012
 Total Revenue
 May
 45,348,931.68
 45,348,932
 Pass
71
 2012
 Total Revenue
 Jun
 57,921,480.56
 57,921,481
 Pass
72
 2012
 Total Revenue
 Jul
 51,672,007.55
 51,672,008
 Pass
73
 2012
 Total Revenue
 Aug
 56,808,673.07
 56,808,673
 Pass
74
 2012
 Total Revenue
 Sep
 63,316,595.27
 63,316,595
 Pass
75
 2012
 Total Revenue
 Oct
 51,135,723.81
 51,135,724
 Pass
76
 2012
 Total Revenue
 Nov
 52,803,467.04
 52,803,467
 Pass
77
 2012
 Total Revenue
 Dec
 26,844,941.92
 26,844,942
 Pass
78
 2012
 Total Revenue
 Total
 562,620,542.25
 562,620,542
 Pass

Group : EMEA Region
SNo
 Test Case
 Test Case
 Test Case
 Value in BEx Query
 Value in Crystal Report
 Pass/Fail
1
 2013
 Actual Revenue
 Jan
 4,968,049.21
 4,968,049
 Pass
2
 2013
 Actual Revenue
 Feb
 5,426,461.91
 5,426,462
 Pass
3
 2013
 Actual Revenue
 Mar
 6,316,257.74
 6,316,258
 Pass
4
 2013
 Actual Revenue
 Apr
 5,773,134.35
 5,773,134
 Pass
5
 2013
 Actual Revenue
 May
 4,805,851.15
 4,805,851
 Pass
6
 2013
 Actual Revenue
 Jun
 756,095.35
 756,095
 Pass
7
 2013
 Actual Revenue
 Jul
 No Value
 0
 Pass
8
 2013
 Actual Revenue
 Aug
 No Value
 0
 Pass
9
 2013
 Actual Revenue
 Sep
 No Value
 0
 Pass
10
 2013
 Actual Revenue
 Oct
 No Value
 0
 Pass
11
 2013
 Actual Revenue
 Nov
 No Value
 0
 Pass
12
 2013
 Actual Revenue
 Dec
 No Value
 0
 Pass
13
 2013
 Actual Revenue
 Total
 28,045,849.71
 28,045,850
 Pass

Group : Emerging Markets Region
SNo
 Test Case
 Test Case
 Test Case
 Value in BEx Query
 Value in Crystal Report
 Pass/Fail
1
 2012
 Open Value
 Jan
 No Value
 0
 Pass
2
 2012
 Open Value
 Feb
 No Value
 0
 Pass
3
 2012
 Open Value
 Mar
 No Value
 0
 Pass
4
 2012
 Open Value
 Apr
 No Value
 0
 Pass
5
 2012
 Open Value
 May
 No Value
 0
 Pass
6
 2012
 Open Value
 Jun
 No Value
 0
 Pass
7
 2012
 Open Value
 Jul
 No Value
 0
 Pass
8
 2012
 Open Value
 Aug
 No Value
 0
 Pass
9
 2012
 Open Value
 Sep
 No Value
 0
 Pass
10
 2012
 Open Value
 Oct
 No Value
 0
 Pass
11
 2012
 Open Value
 Nov
 No Value
 0
 Pass
12
 2012
 Open Value
 Dec
 No Value
 0
 Pass
13
 2012
 Open Value
 Total
 No Value
 0
 Pass

Group : North America Region
SNo
 Test Case
 Test Case
 Test Case
 Value in BEx Query
 Value in Crystal Report
 Pass/Fail
1
 2013
 Total Revenue
 Jan
 24,984,442.16
 24,984,442
 Pass
2
 2013
 Total Revenue
 Feb
 48,717,594.35
 48,717,594
 Pass
3
 2013
 Total Revenue
 Mar
 50,672,418.80
 50,672,419
 Pass
4
 2013
 Total Revenue
 Apr
 35,037,800.95
 35,037,801
 Pass
5
 2013
 Total Revenue
 May
 38,241,556.26
 38,241,556
 Pass
6
 2013
 Total Revenue
 Jun
 38,895,265.51
 38,895,266
 Pass
7
 2013
 Total Revenue
 Jul
 37,797,492.53
 37,797,493
 Pass
8
 2013
 Total Revenue
 Aug
 31,538,992.92
 31,538,993
 Pass
9
 2013
 Total Revenue
 Sep
 25,655,403.81
 25,655,404
 Pass
10
 2013
 Total Revenue
 Oct
 17,035,049.15
 17,035,049
 Pass
11
 2013
 Total Revenue
 Nov
 4,433,154.53
 4,433,155
 Pass
12
 2013
 Total Revenue
 Dec
 940,554.18
 940,554
 Pass
13
 2013
 Total Revenue
 Total
 353,949,725.14
 353,949,725
 Pass

Secondary Level Summary Check

Test Conducted:

Group : EMEA Sales > TRANSFORMERS - HASBRO
SNo
 Test Case
 Test Case
 Test Case
 Value in BEx Query
 Value in Crystal Report
 Pass/Fail
1
 2013
 Actual Revenue
 Jan
 170.96
 171
 Pass
2
 2013
 Actual Revenue
 Feb
 187.42
 187
 Pass
3
 2013
 Actual Revenue
 Mar
 No Value
 No Value
 Pass
4
 2013
 Actual Revenue
 Apr
 No Value
 No Value
 Pass
5
 2013
 Actual Revenue
 May
 106.82
 107
 Pass
6
 2013
 Actual Revenue
 Jun
 No Value
 No Value
 ass
7
 2013
 Actual Revenue
 Jul
 No Value
 0
 Pass
8
 2013
 Actual Revenue
 Aug
 No Value
 0
 Pass
9
 2013
 Actual Revenue
 Sep
 No Value
 0
 Pass
10
 2013
 Actual Revenue
 Oct
 No Value
 No Value
 Pass
11
 2013
 Actual Revenue
 Nov
 No Value
 0
 Pass
12
 2013
 Actual Revenue
 Dec
 No Value
 No Value
 Pass
13
 2013
 Actual Revenue
 Total
 465.20
 465
 Pass

Group : Emerging Markets > LIVE NATION
SNo
 Test Case
 Test Case
 Test Case
 Value in BEx Query
 Value in Crystal Report
 Pass/Fail
1
 2012
 Open Value
 Jan
 No Value
 No Value
 Pass
2
 2012
 Open Value
 Feb
 No Value
 No Value
 Pass
3
 2012
 Open Value
 Mar
 No Value
 No Value
 Pass
4
 2012
 Open Value
 Apr
 No Value
 No Value
 Pass
5
 2012
 Open Value
 May
 No Value
 No Value
 Pass
6
 2012
 Open Value
 Jun
 No Value
 No Value
 Pass
7
 2012
 Open Value
 Jul
 No Value
 0
 Pass
8
 2012
 Open Value
 Aug
 No Value
 No Value
 Pass
9
 2012
 Open Value
 Sep
 No Value
 No Value
 Pass
10
 2012
 Open Value
 Oct
 No Value
 No Value
 Pass
11
 2012
 Open Value
 Nov
 No Value
 No Value
 Pass
12
 2012
 Open Value
 Dec
 No Value
 No Value
 Pass
13
 2012
 Open Value
 Total
 No Value
 0
 Pass

Group : North America > NON LICENSED
SNo
 Test Case
 Test Case
 Test Case
 Value in BEx Query
 Value in Crystal Report
 Pass/Fail
1
 2013
 Total Revenue
 Jan
 42.955.68
 42.956
 Pass
2
 2013
 Total Revenue
 Feb
 35,087.25
 35,087
 Pass
3
 2013
 Total Revenue
 Mar
 210.05
 210
 Pass
4
 2013
 Total Revenue
 Apr
 4,336.00
 4,336
 Pass
5
 2013
 Total Revenue
 May
 1,002.25
 1,002
 Pass
6
 2013
 Total Revenue
 Jun
 No Value
 0
 Pass
7
 2013
 Total Revenue
 Jul
 No Value
 0
 Pass
8
 2013
 Total Revenue
 Aug
 No Value
 0
 Pass
9
 2013
 Total Revenue
 Sep
 No Value
 0
 Pass
10
 2013
 Total Revenue
 Oct
 No Value
 0
 Pass
11
 2013
 Total Revenue
 Nov
 No Value
 0
 ass
12
 2013
 Total Revenue
 Dec
 No Value
 0
 Pass
13
 2013
 Total Revenue
 Total
 83,591.23
 83,591
 Pass

Detail Level Check

Test Conducted:

Group : EMEA Sales > MLB PROPERTIES > German Sales
SNo
 Test Case
 Test Case
 Test Case
 Value in BEx Query
 Value in Crystal Report
 Pass/Fail
1
 2013
 Actual Revenue
 Jan
 15,471.64
 15,472
 Pass
2
 2013
 Actual Revenue
 Feb
 16,708.66
 16,709
 Pass
3
 2013
 Actual Revenue
 Mar
 12,881.68
 12,882
 Pass
4
 2013
 Actual Revenue
 Apr
 33,819.74
 33,820
 Pass
5
 2013
 Actual Revenue
 May
 22,212.78
 22,213
 Pass
6
 2013
 Actual Revenue
 Jun
 No Value
 0
 Pass
7
 2013
 Actual Revenue
 Jul
 No Value
 0
 Pass
8
 2013
 Actual Revenue
 Aug
 No Value
 0
 Pass
9
 2013
 Actual Revenue
 Sep
 No Value
 0
 Pass
10
 2013
 Actual Revenue
 Oct
 No Value
 0
 Pass
11
 2013
 Actual Revenue
 Nov
 No Value
 0
 Pass
12
 2013
 Actual Revenue
 Dec
 No Value
 0
 Pass
13
 2013
 Actual Revenue
 Total
 101,094.50
 101,095
 Pass

Group: Emerging Markets > NFL PROPERTIES > NEC Korea Sales
SNo
 Test Case
 Test Case
 Test Case
 Value in BEx Query
 Value in Crystal Report
 Pass/Fail
1
 2012
 Open Value
 Jan
 No Value
 0
 Pass
2
 2012
 Open Value
 Feb
 No Value
 0
 Pass
3
 2012
 Open Value
 Mar
 No Value
 0
 Pass
4
 2012
 Open Value
 Apr
 No Value
 0
 Pass
5
 2012
 Open Value
 May
 No Value
 0
 Pass
6
 2012
 Open Value
 Jun
 No Value
 0
 Pass
7
 2012
 Open Value
 Jul
 No Value
 0
 Pass
8
 2012
 Open Value
 Aug
 No Value
 0
 Pass
9
 2012
 Open Value
 Sep
 No Value
 0
 Pass
10
 2012
 Open Value
 Oct
 No Value
 0
 Pass
11
 2012
 Open Value
 Nov
 No Value
 0
 Pass
12
 2012
 Open Value
 Dec
 No Value
 0
 Pass
13
 2012
 Open Value
 Total
 No Value
 0
 Pass

Group: North America > NBA PROPERTIES > 5th & Ocean Sales
SNo
 Test Case
 Test Case
 Test Case
 Value in BEx Query
 Value in Crystal Report
 Pass/Fail
1
 2013
 Total Revenue
 Jan
 3,490,040.98
 3,490,041
 Pass
2
 2013
 Total Revenue
 Feb
 9,718,847.12
 9,718,847
 Pass
3
 2013
 Total Revenue
 Mar
 5,739,158.17
 5,739,158
 Pass
4
 2013
 Total Revenue
 Apr
 2,155,436.25
 2,155,436
 Pass
5
 2013
 Total Revenue
 May
 4,987,729.63
 4,987,730
 Pass
6
 2013
 Total Revenue
 Jun
 3,602,313.25
 3,602,313
 Pass
7
 2013
 Total Revenue
 Jul
 4,537,604.93
 4,537,605
 Pass
8
 2013
 Total Revenue
 Aug
 5,615,402.34
 5,615,402
 Pass
9
 2013
 Total Revenue
 Sep
 663,905.13
 663,905
 Pass
10
 2013
 Total Revenue
 Oct
 26,972.16
 26,972
 Pass
11
 2013
 Total Revenue
 Nov
 No Value
 0
 Pass
12
 2013
 Total Revenue
 Dec
 No Value
 0
 Pass
13
 2013
 Total Revenue
 Total
 40,537,409.96
 40,537,410
 Pass

Reference Document(Specification)

2013-06-03 - 7490 - Enhancement - License Tracker